-- TODO trigger: alter ammo / barrel to a gun
--   -> recalc muzzle velocity / price / ...
-- TODO add 3D models names && sound path || use names
-- cd add a brand alias (letting matching 'IMI' instead of 'Israel Military Industries')
-- TODO add haircuts (or add them in measurements)
-- TODO split in several files
-- TODO add drop_rate stats
-- TODO add containers management (helmet webs, pockets, ...)

DROP SCHEMA rods CASCADE;
CREATE SCHEMA rods;
SET search_path = rods;

-- Tables
\i one_to_one_tables.sql;
\i users.sql
\i characters.sql
\i items.sql
\i inventories.sql

-- Tools
\i functions.sql
\i triggers.sql
\i views.sql
\i default_insertions.sql
\i tests.sql
